<?php
require_once dirname(__FILE__) . '/../includes/common.inc.php';
require_once dirname(__FILE__) . '/../includes/pdoorm.inc.php';

header('Content-Type: text/plain');

$sql="
CREATE TABLE `ns_v1purchasenote` (
  `e_oid` int(12) NOT NULL AUTO_INCREMENT,
  `trackId` varchar(64) DEFAULT NULL,
  `author` varchar(64) DEFAULT NULL,
  `date` int(16) DEFAULT NULL,
  `content` varchar(2048) DEFAULT NULL,
  `cancelled` tinyint(1) DEFAULT NULL,
  `purchaseitem_id` int(12) NOT NULL COMMENT'purchaseitem编号',  
  PRIMARY KEY (`e_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
";

sql_execute($sql);
